SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441300 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441300 [ RunTime:0.004165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146886,282697,567064,734963,419120,749987,112785,1041185,68324,80640,286923,607868,306139,736804,813555,427472,931787,847949,822251,829600,474892,29966,408675,1010684,319077,557700,699950,35110,119480,884054,677912,930040,369216,600452,990227,436335,942447,704085,537598,541991,1042773,249977,1008522,936374,419176,397669,46632,309507,967778,804525,83117,189940,246277,1010316,3639,187454,307462,211141,687113,578571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]