SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004525s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40569 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40569 [ RunTime:0.003174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592348,326620,70724,960444,840748,540216,923910,957444,956285,288298,780282,653053,803192,720655,888090,601976,800794,556736,888711,925389,506868,189089,625387,937149,167846,939376,592152,350752,86896,181624,890107,357993,223168,843531,488405,1015561,253583,860578,1033609,1007698,311427,458798,886445,1044996,690898,630680,344552,240705,80582,538284,846786,476819,752651,145907,1038437,721751,551396,658644,210578,973197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40569 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004832s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40569 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003632s ]