SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381998 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381998 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34895,931051,480463,888064,696205,176096,151233,42358,957588,737120,540229,870642,69168,599775,223168,651568,940762,564023,328420,436796,182673,552294,314239,321778,699261,1008499,160066,107066,46090,679574,576630,857896,51930,830832,564345,972822,99144,279200,1045096,781219,668042,306821,460801,894407,492342,359778,635643,250599,184997,816593,643355,365589,743977,198999,353290,665981,398259,640372,274558,155447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002549s ]