SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417118 LIMIT 1 [ RunTime:0.001614s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417118 [ RunTime:0.006058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831937,989714,1047694,359655,44211,316582,833687,854934,982737,724501,1029414,498206,745157,982119,226615,707702,185225,375821,633077,635749,761870,54747,835856,513112,144917,825278,160698,256940,488863,925656,348830,6238,213894,613089,763782,851497,676410,152150,268297,777877,299113,778673,225694,172303,985599,844330,282212,645623,485007,589226,100151,209345,371400,673056,63868,818882,292371,77870,561582,868298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]