SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011242 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011242 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846585,824977,7479,912263,520531,798149,382964,1039373,165140,782292,838311,826883,326915,1047726,894839,192079,277765,780962,201540,940186,390280,776220,164390,357373,462255,620415,638851,413654,570324,393283,754845,783111,691861,950288,306432,1002660,997266,327416,26556,39027,195862,969630,963288,677448,643824,1045890,125865,1001836,910104,845213,1043291,876903,236704,1029081,614013,770087,167151,690582,111642,875667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011242 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011242 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]