SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020875 LIMIT 1 [ RunTime:0.001029s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020875 [ RunTime:0.004876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (84233,747337,642932,732801,585365,45357,683488,154364,78830,723962,133961,903006,572933,627528,814307,428731,758399,264380,290670,67491,110234,236294,598685,777121,628755,368122,773670,328979,886275,1032455,870703,973084,1007506,567979,1008833,488250,364700,590037,282405,845696,490502,107212,586970,261786,568409,909345,747557,869190,954599,427103,259351,392520,547631,111347,113356,324899,995999,284960,5357,975546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.019444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000815s ]