SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284584 LIMIT 1 [ RunTime:0.000527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284584 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344219,257014,549197,707845,317004,293283,668744,442901,632658,1037179,1011287,1024281,555218,313301,173631,602054,105061,337797,654559,984350,907310,972908,206412,682283,843680,24689,1025934,210209,839546,116460,30938,735959,592431,795299,336936,50307,209447,381340,779343,897455,186221,1008431,674152,744453,505630,552401,125511,811491,426726,156259,1046814,117554,965638,393066,615908,966717,593863,31392,839177,683527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]