SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423346 LIMIT 1 [ RunTime:0.000742s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423346 [ RunTime:0.002091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522157,818162,652070,257394,297268,696676,822931,778266,823818,442225,830650,421616,981248,484833,220854,740184,753152,655833,290765,478772,631710,834396,983156,1038408,186064,24515,610621,274237,810324,292110,292401,794431,921317,233946,814940,811884,228808,438028,569732,895251,587375,316396,537410,359901,301586,441132,133840,206305,794399,563675,362873,733980,749690,224158,198080,563491,449249,468691,801575,598147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]