SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544097 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544097 [ RunTime:0.003477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929039,482104,705061,903468,613362,239412,939519,436324,383967,922982,146269,755465,421961,863904,497289,310336,64284,1015209,1012560,74324,11003,152347,528703,108548,62173,217337,45893,933020,787194,746114,249497,692231,645746,527184,979876,691987,166818,795650,958182,146592,531178,791953,883081,534785,333256,389840,289138,562328,813651,545907,977407,894883,902407,500645,372378,175210,740646,866408,152376,59720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]