SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194048 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194048 [ RunTime:0.002150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471019,162268,690568,326926,591523,10930,902770,268554,859206,118991,603458,348068,932629,439854,743630,567534,446947,397050,695816,155100,748103,271176,819107,875547,925279,51990,107163,80726,861176,599881,242940,363726,945241,589786,26243,530256,1035197,13847,904897,418800,627967,775190,31587,357761,1043723,529080,223197,126272,322305,681931,775230,430918,812482,534963,843694,462380,579209,1033668,539287,972851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]