SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554234 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554234 [ RunTime:0.002203s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350036,1025137,349516,687818,741843,687404,1019054,128098,736184,651392,372934,370882,538329,665848,402926,264095,618367,32325,965295,336812,557625,744634,315226,768854,885998,1010318,105205,750445,912267,826915,942907,633988,874966,272922,781710,628806,934546,334130,605970,442572,32099,981873,648933,16940,451400,575205,617284,462210,882423,1023328,224737,399316,149729,434497,673964,357807,50729,546944,296786,259624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]