SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291056 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291056 [ RunTime:0.004210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923757,784369,912498,322944,365747,931170,4854,15860,76490,536123,9052,802266,808342,1013778,234999,379264,115737,982019,337931,1009019,888385,671804,530091,938850,973994,658870,869052,715834,44155,362318,1007412,641236,156312,475337,337726,28730,426650,927640,162588,817253,250426,57227,455143,652790,582906,282678,832495,431540,57206,75746,267335,818678,444005,77942,797827,609270,441728,333931,299484,816846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]