SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 116917 LIMIT 1 [ RunTime:0.000550s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 116917 [ RunTime:0.007458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019761,656955,938313,1044526,251083,323216,1021106,630090,840715,636221,998131,302829,1000309,770242,459495,1032172,402389,689104,943984,892475,156679,26775,222268,389081,76306,870418,132866,400754,834292,1021127,662184,357925,951883,892030,408289,772697,707475,50166,1003174,131464,913595,329023,1044806,1002927,329887,310752,304367,162959,475988,628880,461181,88256,118242,488249,611899,989881,411220,864637,900612,35552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 116917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 116917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]