SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200635 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200635 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468313,317179,737834,759296,687709,689335,862965,975550,145487,506439,84795,760938,1040641,359062,704501,799341,115823,154953,321021,115235,510813,693152,800210,155783,890783,83141,234736,94296,729188,960731,457782,318154,309343,842339,196192,585723,1034339,6082,205945,873793,971482,276798,291682,427599,203429,343144,303419,625140,134028,119986,196069,803972,975667,482982,719658,908895,259590,247003,211704,748718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200635 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200635 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]