SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292644 LIMIT 1 [ RunTime:0.000559s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292644 [ RunTime:0.002578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450204,273821,463901,1011071,363564,193931,719650,505181,142169,139524,236549,510087,277182,407764,401332,293752,918498,799512,799899,551829,530369,288258,1023274,397255,449753,913548,626588,635816,845220,915713,115820,511443,521632,523854,698514,263481,207501,258070,33941,6623,572675,100701,822241,372467,665029,327504,886501,69865,73998,955516,648160,477074,882680,432396,38397,723627,194787,734907,480877,71809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]