SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584400 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584400 [ RunTime:0.002057s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (727311,57164,380574,881900,153428,57029,641754,372190,478606,107766,1029844,545082,879712,713400,141246,946530,992365,642095,618288,601781,193556,553172,15402,684115,588125,155548,6715,700639,1023963,166924,110663,368342,769603,966769,442581,973722,894278,231324,293015,571481,361213,1028939,1010598,20039,549724,384824,19158,320497,829450,1005873,857850,1021798,476601,753089,612377,510593,369230,830800,580442,543578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]