SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802541 LIMIT 1 [ RunTime:0.002913s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802541 [ RunTime:0.004831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719858,6335,539191,273572,206342,253989,639399,578904,13685,628333,26326,544525,940463,903982,383589,552645,525180,136593,814412,382559,99286,89457,460501,1047355,480331,974248,977616,839383,312562,934296,666102,577899,112869,310929,1036235,126453,59003,713691,486335,82219,430368,821848,48675,472255,534934,625682,932410,857226,705388,246771,309747,187330,718026,235830,551968,597126,876295,392313,589203,97282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]