SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518506 LIMIT 1 [ RunTime:0.004290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518506 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014901,126716,193054,734995,353472,679139,279880,396459,189979,69356,872109,502488,243166,974887,900458,811938,669009,1043747,205563,953238,962243,569446,984847,301198,612546,749891,884312,94264,383077,726885,729354,905498,152690,642651,853417,388845,461622,496538,705913,342561,22207,459611,533086,912893,545746,139812,912573,374753,242055,565732,427968,280551,83544,347175,999682,806216,732463,492944,351532,388202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000710s ]