SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401443 LIMIT 1 [ RunTime:0.001541s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401443 [ RunTime:0.009123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52441,67130,547617,422010,650046,328747,912060,226517,115160,23860,433706,333220,217352,75129,751049,112371,399201,9465,473377,345668,294980,818261,2114,415987,229771,209525,515802,70387,991183,192691,463011,628487,898468,994396,535984,404817,704496,478564,637738,132928,847169,1017106,356960,689201,90958,246682,9462,1029437,703573,333666,270532,268716,538512,782699,732633,517079,304093,538919,268577,399767) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]