SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 784512 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 784512 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468923,785621,940269,330692,442645,479095,458673,90517,27850,761328,726186,275410,812735,942555,460157,883859,756932,693954,725938,471992,784237,1027425,924599,541207,388887,24173,698247,796265,49153,309016,1047381,312002,59602,167749,3982,303492,45147,819632,819160,590403,1023077,1005970,807808,100791,312832,576149,1043263,595421,500543,112558,425717,394052,179514,82482,418925,579972,837434,265847,516396,971627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 784512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 784512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]