SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284529 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284529 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151976,615273,551113,461699,300402,913635,755119,433982,45746,96908,882551,154265,748359,129582,707769,448068,723400,1006044,16283,603656,630230,373600,480628,386896,598238,510135,237943,1040232,922416,792342,778976,902824,93522,200888,421452,43992,870775,823612,965452,560874,580220,709070,385583,1032121,116977,537443,782391,400579,179038,607015,84736,711471,913683,8747,890874,750688,464389,261398,945257,284202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]