SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013404 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013404 [ RunTime:0.004468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362593,582543,847688,643701,759809,263804,233295,687949,961494,364704,707591,383147,1219,167336,813413,951420,154917,923073,66750,74286,670887,713183,966842,915283,976200,180834,27447,653353,394487,245206,823690,709460,51748,744052,499882,343509,867639,597289,826385,692735,548520,482907,1021116,681989,27698,357512,139191,706469,257292,101863,615341,138554,896791,611087,235516,347574,988369,590613,356064,948398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]