SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001581s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461052 LIMIT 1 [ RunTime:0.002306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461052 [ RunTime:0.004470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812858,396002,127050,63078,975440,197,992213,462819,248245,483554,399287,236569,938883,657641,450430,731999,821363,276552,664171,260823,725609,594783,102717,871228,494280,888058,481193,411132,212895,255566,437940,442281,52502,436382,287450,303947,17564,803747,940313,175801,937770,613576,237633,57363,237271,49502,210723,41758,230682,218392,151345,570900,932313,83129,100130,366075,278697,213129,633759,848560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]