SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200698 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200698 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (776054,393595,176089,517290,110096,127003,526992,750505,955523,479003,123963,456767,684272,316328,239340,449762,939186,793492,652356,167294,1007569,978909,437950,17206,966831,512948,594429,859016,501979,182818,823748,698619,1031276,934814,519015,713786,127353,955144,950089,607325,295122,749310,110620,928318,759434,161113,367123,17574,377806,176406,574917,504292,990990,792964,240006,586188,242842,599191,370101,827662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000958s ]