SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193875 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193875 [ RunTime:0.002171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802643,118950,388982,528654,770718,608938,194228,960885,726721,87255,689094,108021,442346,101883,148211,41744,53348,266508,490743,655569,937596,280354,931381,631021,36933,808952,384032,546776,365779,735933,180726,665931,176280,739280,574780,332651,1015605,864981,765715,375263,514150,297291,252732,335062,67594,661393,503730,710369,279224,29317,825201,815177,650730,338655,1032013,460326,30357,531683,1015075,60956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001189s ]