SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313355 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313355 [ RunTime:0.002239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004815,180713,512105,680511,404216,283908,440978,688156,18595,898412,71189,83615,395130,618034,115107,414510,118219,1048112,419095,1009295,222703,21840,757532,630972,36336,610410,45954,355848,645798,905364,776814,5391,1001380,50019,774156,668104,860760,1038247,560259,256173,306923,571142,509233,767659,25202,681244,801283,686607,1046333,354506,1946,182874,368414,289170,137238,153041,733969,1041386,313541,581360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313355 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313355 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000997s ]