SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 881041 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 881041 [ RunTime:0.002323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410693,12755,89094,270235,44726,23136,502390,52690,454538,40076,262624,420475,951492,552877,795831,229975,732475,685478,396885,433282,475359,62346,581172,674896,315370,520688,348701,403975,134564,794422,410853,804539,673644,589977,1002268,528536,474339,418606,480950,543849,576317,557652,497878,546194,1041160,172240,658215,165029,993657,48343,769818,170525,638782,640699,489388,296706,929618,416862,971498,289586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 881041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 881041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]