SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439544 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439544 [ RunTime:0.002114s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014083,184196,464454,916883,591684,829590,489617,4656,640996,691924,288054,791818,304834,387756,830451,237034,520530,217513,774521,1005667,312214,923224,266590,260536,42841,52405,285090,27605,469841,555966,784188,118629,1040536,214778,846714,53465,119827,397000,786468,743014,1038251,538379,548402,635977,869611,1038189,144662,676748,992994,708542,234471,97076,133424,425216,36500,295880,728620,264675,679039,978484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]