SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522862 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522862 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592055,682113,618763,448467,210979,64777,195775,836629,776003,466300,543317,410129,120369,503553,650952,490161,600107,117471,682495,990507,125819,1015830,972449,164943,1032434,839969,505294,132444,523897,719865,113575,1005840,293220,274165,274391,105255,870678,142166,28660,889348,623714,7524,223829,927683,132555,929321,275900,17103,168748,155338,366596,665854,57371,720723,1035530,372089,615540,47892,243121,843410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522862 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522862 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000389s ]