SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984512 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984512 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459295,484658,72971,815363,897106,340366,559732,994851,528465,434850,717759,914270,167091,725705,187471,199205,120189,55725,437899,57865,928307,215799,982836,182469,567827,904653,734193,903767,230346,814877,809437,885038,455993,198053,583496,215607,938292,542761,831708,884376,650687,645034,395884,485543,530545,839673,573259,1048249,268233,961481,61900,496668,520813,144476,88853,561028,986920,678776,970220,492049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000723s ]