SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534760 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534760 [ RunTime:0.008242s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18978,877390,629849,286210,42252,737640,66425,112453,126398,774673,900502,655897,989374,257697,43481,164257,132899,5302,642686,313098,310770,587674,147737,869008,836088,525387,274296,284112,446419,795239,1002306,620282,120484,673262,638981,26723,539187,339731,431387,594294,347416,1042041,585378,222958,64480,1012399,340784,169993,501100,887815,716647,335388,611316,451669,59682,379649,754436,663509,464237,642450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]