SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330017 LIMIT 1 [ RunTime:0.000758s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330017 [ RunTime:0.002588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530660,223101,398906,562663,852524,21122,544680,976738,632369,442446,603498,340030,837775,763161,812727,229928,829632,185615,910575,5337,785427,762181,60539,86583,585430,232933,950585,522425,4075,499343,814759,14621,518744,629733,799494,758965,628661,718312,7321,289912,254281,176696,409307,216931,168608,915256,339184,335041,729561,213266,790148,41818,209523,672841,492235,924656,265498,160182,812184,472791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001289s ]