SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421401 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421401 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199495,873226,375049,400698,317075,606721,81208,38879,882649,968249,634654,875484,623802,997555,634588,717625,390887,108895,427508,687053,711639,397490,902607,359114,540517,380854,1001317,100127,343744,71792,228204,660752,177052,172,277418,1047864,112118,895909,577237,679706,110349,107248,16749,214719,398976,804547,20782,399189,674316,778297,444855,863856,203262,586363,558428,21932,744628,885256,130730,357102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000902s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]