SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 306706 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 306706 [ RunTime:0.001331s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605079,839104,91840,892115,1015352,672317,441941,573970,1032208,915394,69088,6267,69013,175677,251661,950781,340484,298169,420485,1010372,525228,660754,412671,460652,706179,762122,818754,59471,160547,39412,775974,786495,69959,1025815,756558,141220,211922,195147,94500,804945,232527,778360,400877,44790,740250,130670,530047,394973,673668,298755,311309,380270,679240,220936,672725,609727,155525,536686,866669,341568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001862s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 306706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 306706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]