SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004751s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356283 LIMIT 1 [ RunTime:0.005483s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356283 [ RunTime:0.003191s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288398,541390,447824,592902,959193,123299,241778,361283,816511,69555,734974,76221,796310,279129,458810,967714,196611,109535,341578,791,435455,81834,887564,401426,6173,32366,97180,77180,241388,692620,705506,908640,643314,448402,1045098,727805,1013774,862059,851911,729931,38558,375499,505109,302688,542510,294350,872626,396392,862939,55497,277412,257215,883442,701176,527371,953295,50503,993017,216976,818255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.008501s ]