SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290540 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290540 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (933039,599809,407366,977063,597594,315031,237921,310456,416553,766643,632134,453330,214890,753506,119609,879513,260117,62060,521409,532383,727635,201283,279116,13469,249832,385894,903364,334035,20762,635547,62143,415173,172255,931481,892626,600139,543013,449775,558247,210545,657779,650642,596223,240755,983453,582779,346345,691466,513872,182547,604770,949397,625624,316600,175185,798143,214698,76647,442624,158687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]