SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014209 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014209 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288294,721257,449903,15191,11777,107882,623143,230443,4079,160009,537020,798744,739136,399252,970315,199999,416879,921632,111526,577275,109387,60150,677723,822275,93731,531349,599353,990822,19435,207526,78673,419189,557173,69938,90755,405500,373923,980691,64414,82347,603158,335574,47,533754,764644,282720,1031323,1046497,578967,434078,358338,712048,793815,486047,744819,140990,250817,484254,511324,727363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001790s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]