SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402790 LIMIT 1 [ RunTime:0.000708s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402790 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (859152,449151,729243,235533,604410,255175,1047141,101415,124788,631912,266910,752982,87022,246556,852171,413413,975902,672787,573171,331295,935381,297931,572805,627414,126436,1027809,457468,117695,641175,643657,563661,23209,275800,412846,391121,535257,925563,841023,381582,597262,478338,507800,574345,704037,877657,477852,133968,512478,636814,506778,66545,428948,414677,350984,272091,60738,1003569,408733,746567,1030912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402790 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402790 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]