SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578470 LIMIT 1 [ RunTime:0.001166s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578470 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316850,113516,449422,168440,954922,891756,859783,555156,1022558,920774,653771,169325,120813,433241,325254,702443,988571,705574,297961,62187,39718,69269,320887,579805,507029,917601,516395,212856,827004,799845,469390,76734,1005394,854762,198322,274709,1022806,352088,569894,706853,105816,891694,610921,290001,917352,248034,95666,229369,505078,348635,509572,294865,73607,529914,136568,399259,838572,47447,691421,46669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]