SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104084 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104084 [ RunTime:0.002491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326800,978716,115968,894980,997039,377300,144537,23721,886877,1026932,425591,8776,838455,942560,493001,60494,112121,28994,190318,948785,485520,130830,434870,18828,248282,366227,221926,404270,789045,716371,157299,737285,873480,720533,914367,882201,282520,614438,887977,487883,245148,661440,383289,223588,13579,669982,630714,1001507,580590,624973,417500,879949,1004589,822759,652859,11468,454264,466731,526920,391414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000907s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]