SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404608 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404608 [ RunTime:0.001553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586693,219547,610524,189080,787534,46032,307402,756055,173139,383895,395085,216795,582569,536443,231832,132069,37721,943780,968369,870462,465174,1018665,167515,278669,262712,676567,68684,571685,1039796,807298,167961,577252,973877,342958,242177,835742,772551,742014,847595,908229,727585,195729,746361,841317,583306,247852,752954,104859,324337,293838,578376,683358,492020,865275,432338,132222,676329,984204,916275,417097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]