SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 175988 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 175988 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145599,928821,247023,821065,340201,786430,238567,757003,869515,415997,972229,987954,1014416,84235,306822,226453,600211,240213,189050,433618,186234,439508,575713,656354,182153,76445,161851,22110,504801,752407,504301,423726,337117,854554,214207,985584,277161,953890,240428,265170,474769,881734,765002,797845,115670,568920,586440,760621,207489,958786,709193,3933,133168,94569,928484,758549,117853,629725,750090,746348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 175988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 175988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]