SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450545 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450545 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047222,841806,60842,791132,849393,390900,581670,739484,47568,823785,489951,799029,978328,351102,158161,785208,826404,646535,157501,1042207,250742,548028,127612,879768,240862,499024,1033106,367576,217255,618616,563940,62429,425046,315363,954087,356188,135394,925200,677663,687949,560685,637069,630855,702779,620442,614501,98685,619833,368406,995257,717650,634672,941126,749508,393189,113669,136333,803575,848888,225001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001463s ]