SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019597 LIMIT 1 [ RunTime:0.002454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019597 [ RunTime:0.004325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134573,251009,642421,1010053,750551,465090,178987,596732,134904,481641,889046,398432,277399,266934,188540,142580,117092,78771,525796,967213,489575,267045,757952,464504,749738,236214,411202,681070,97747,873390,303444,871434,217034,492545,287426,320665,938934,86795,536929,510682,988805,488836,345101,530589,379659,4151,832062,690268,880295,766910,570451,351763,946042,382819,313991,398327,524646,942146,154663,1046422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019597 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019597 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]