SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142150 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142150 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202956,23503,85136,992051,616883,214343,672326,412795,206915,477503,526393,483088,12266,887965,840886,612235,983540,1013680,75628,358399,468126,359547,118152,537163,565361,728654,153002,246604,286572,632780,849122,522529,518907,425229,709762,970328,550188,728504,698603,156617,908682,139720,391354,794146,563847,105496,196317,813989,969437,423378,881169,939889,1020869,221459,860230,99149,973603,975776,526861,692762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]