SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047609 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047609 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (227652,346935,788117,518213,638707,547872,491694,383717,268492,14827,618314,282245,646850,477481,359641,157958,1040759,946379,685323,683643,316912,1012874,614742,378416,43243,1017993,754907,372365,755703,18819,550696,255192,139179,838044,879128,762832,757461,349295,631123,666317,1033267,812374,861286,432691,778409,767851,492553,311847,671398,774921,1048636,221507,342968,400943,278544,14977,417043,64346,651933,255014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]