SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 76108 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 76108 [ RunTime:0.005302s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029659,278086,284195,225401,727246,621645,432217,33136,775544,87229,377343,516895,850390,199086,449190,383746,299552,328126,258510,919791,25505,222391,566257,681593,1008990,1035897,284069,898526,241764,500743,982596,81983,399639,34170,587372,717944,661977,4445,748088,747998,256185,481135,554104,129477,190985,83112,652446,106967,164632,729973,519669,848404,133314,996506,546222,565302,273371,994443,349219,534414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.019922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 76108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 76108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]