SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340610 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340610 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731622,358833,495631,816468,198187,1031238,913062,195060,497194,56779,444506,397753,915428,742774,745433,132568,19893,646436,35859,957319,139087,949030,822117,1026110,29757,416704,772694,908387,680657,573638,998641,215705,84591,620699,945529,73086,366132,912605,743634,630836,798060,21439,658843,375989,945611,76818,828171,557127,88799,361212,275899,743005,1028690,701758,860900,284222,718253,30608,861121,1036268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]