SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527203 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527203 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203809,449015,419428,195278,413728,988807,924720,261020,711631,788978,660164,116248,477198,368605,366099,980252,49380,97453,482284,525933,247430,903137,534334,734450,210391,301375,44971,460025,894414,338114,762375,873821,165089,367339,37683,707744,399698,707530,362359,850559,263268,122769,325128,483548,50168,206058,666544,759055,862755,932354,557714,139965,789779,798727,485804,885001,601394,379184,177907,1024766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]