SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001474s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200419 LIMIT 1 [ RunTime:0.000568s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200419 [ RunTime:0.001968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581159,541262,147360,238555,342870,932729,438780,465359,876655,83483,756006,495810,418628,429135,419840,968042,66124,158760,563880,427739,288557,277384,454727,333223,193202,237817,973135,85648,934249,349421,802321,795341,423001,927461,352010,615274,49418,367628,351169,674549,19786,54985,523474,263423,646160,336473,77723,886137,893845,968307,465127,464419,726203,350217,861550,863727,173897,944069,685266,358632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]