SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002014s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541234 LIMIT 1 [ RunTime:0.000536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541234 [ RunTime:0.003301s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680090,107145,952132,951203,658661,362427,401297,161133,140489,573464,1045394,83377,978378,145226,111522,673578,765760,971589,913799,778587,539105,481944,1018760,198657,786630,36918,366145,838888,244945,519227,92227,671453,806509,909461,398700,433706,826192,977082,479764,22173,691286,75321,583431,693038,83189,504515,700785,319078,495418,524506,858840,225355,97177,120186,727025,188951,551424,704866,136214,172296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]