SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 94180 LIMIT 1 [ RunTime:0.000681s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 94180 [ RunTime:0.004111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208873,674471,461517,140079,152724,540275,122862,719482,89936,785761,523742,190137,372431,792853,745804,864263,188238,221952,56032,572849,379172,427317,856388,324673,523689,49830,465607,592918,278979,949923,936988,614985,208162,661429,560083,309639,517636,420782,263708,312238,288328,799975,218621,1027317,268238,335711,85753,383380,632019,432059,935720,339162,1027159,781907,996826,531673,579098,227773,146656,101027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 94180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 94180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002420s ]