SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539323 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539323 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575638,209087,519303,112497,670551,460946,546190,139069,387897,936227,723311,770435,916818,849077,171294,45825,643652,17229,59846,568617,955391,849625,277373,793187,452441,225574,140030,470397,568663,4712,583716,714298,433580,312478,147273,1043423,600820,65776,866088,33139,38831,349809,168281,166251,958387,630235,874409,301672,668577,682825,875588,220627,548347,334087,499862,119894,58804,796495,767252,453144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]