SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 600108 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 600108 [ RunTime:0.002648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510424,931936,5532,492966,247520,74831,760208,456429,893548,141731,344504,91529,962953,35184,269416,848468,351651,1002445,817643,649142,711229,243811,75751,300352,204439,516066,542796,258329,900411,501475,92529,188273,669927,212678,876169,544564,403816,120546,92871,99287,646862,678439,423828,31755,942091,1014523,680506,278037,247535,426641,475378,872546,682887,660528,534324,908121,563213,1034439,705700,949741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 600108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 600108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]