SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018871 LIMIT 1 [ RunTime:0.000680s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018871 [ RunTime:0.002436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886998,411751,212798,1016094,295452,905048,688052,167399,1016046,239212,590067,310271,768660,14869,853462,944682,457095,748087,711759,930388,972230,585525,69948,262177,20552,190091,398596,720267,716855,871895,948630,464984,394171,12815,285366,391020,447717,114878,208092,846834,14816,539530,822847,577969,1027612,695239,632671,543112,776428,107185,129928,122928,830899,147216,195481,917278,665420,517161,592706,299705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]