SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327811 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327811 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380814,421036,916551,952988,250656,483246,522101,468467,817678,23469,151718,312725,366873,110965,746440,334523,86324,547377,745848,422581,664752,185340,211639,1046060,489498,991372,853865,798414,842307,1032230,557267,314095,795547,986437,1045516,340389,859921,629572,363652,736070,289135,127763,473601,931289,314099,1039915,746908,537533,790980,982854,675613,532737,147199,342584,572128,67551,716639,35605,956141,430196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]