SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 552954 LIMIT 1 [ RunTime:0.000592s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 552954 [ RunTime:0.002716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505187,1005790,726651,437495,674532,847932,430982,123124,973765,955993,653962,698879,160816,854825,362923,608734,268076,1018513,541515,172957,36363,663318,306514,921106,332380,178071,880557,575865,718667,976860,357133,1037376,613067,301676,808385,510713,1035354,510169,186119,888092,305979,115423,152074,205780,492862,401287,911044,453901,979291,513433,497762,339368,661360,348116,379867,21272,1005492,593634,808103,205224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 552954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 552954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001530s ]