SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435191 LIMIT 1 [ RunTime:0.000579s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435191 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046701,883987,503468,544769,696104,912438,13235,763884,129780,893570,298781,1001592,845312,1031304,331279,764494,599031,662533,360447,381115,492212,58190,628524,829294,204919,949167,890386,50121,472193,395905,968097,629461,738652,222801,656395,265410,594565,238275,802528,631765,994967,58525,1033793,168345,480160,833151,577895,591562,323075,61220,736320,669762,383392,40602,581534,381258,673383,468934,784752,800506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003472s ]