SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 365023 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 365023 [ RunTime:0.001929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975553,68934,557638,394284,529664,340115,526719,1016412,322645,794808,913233,181695,2031,903358,1013288,775105,311737,849963,992437,720264,646334,5433,278403,915819,41669,850739,881753,589512,928413,105716,946555,235169,817313,444346,514991,33587,934851,890697,153182,275190,469774,974258,458499,414136,581402,368607,69040,471357,115788,897595,358286,434843,801244,961754,978487,60095,960281,306717,776698,245569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 365023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 365023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001051s ]