SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501745 LIMIT 1 [ RunTime:0.000548s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501745 [ RunTime:0.002118s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700618,638973,623045,765367,896299,730946,380184,258070,36081,769481,763128,549284,345771,544238,604059,358556,310291,483678,1043160,885970,608812,888215,848119,96369,1011403,28136,866343,138191,501339,725281,169257,478585,305540,661841,368694,816989,827318,922368,709608,461360,687596,743735,475975,41721,877362,691368,334565,295375,533343,432686,4061,1004705,468204,201639,579737,453699,948334,68085,255336,662030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501745 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501745 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]