SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001683s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433894 LIMIT 1 [ RunTime:0.002232s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433894 [ RunTime:0.002372s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407052,667173,692743,177216,1016487,621978,10880,453697,830289,180096,869271,973330,779100,487300,35824,4394,311523,250926,115443,750041,250225,586977,9153,243245,502474,719786,692691,710618,139892,568834,292401,1028250,514358,124901,913347,447137,765710,322458,424958,193188,1023336,365328,895801,858397,830973,914852,602020,1039968,73096,30318,75150,315516,333150,967622,314208,865485,204473,489313,454229,175027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]