SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340141 LIMIT 1 [ RunTime:0.000582s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340141 [ RunTime:0.002487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (215487,757820,258416,253378,744771,593222,828791,255643,548827,43736,374353,635790,850004,977618,55346,992955,719412,406012,626601,81172,486598,359514,547544,474454,589559,761569,477987,477223,564238,28148,451304,832648,537217,40626,714211,402269,623104,60116,180395,1014273,932144,966753,56092,348151,399717,592367,392597,793695,391649,433706,536402,834599,472366,450606,581801,709638,83136,476197,672630,590883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]