SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391975 LIMIT 1 [ RunTime:0.002226s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391975 [ RunTime:0.003894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311817,337279,232957,556709,337438,482728,374668,799480,489348,1740,272792,295082,407816,814283,119522,154388,184047,316710,347540,750350,586374,505492,375102,217973,584547,137206,968547,1024565,715231,740014,222631,394900,227901,694063,331166,312208,422756,894712,725337,471437,567835,793639,455887,809421,583656,802264,393066,627361,915849,607854,632200,589328,727304,905001,299051,481164,769735,688274,992844,103310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003731s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]