SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 669691 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 669691 [ RunTime:0.002740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608484,962295,169336,678303,455841,982151,274671,417414,778003,838534,1000436,447799,478963,156984,463631,604120,447835,620107,871760,283243,559028,601408,321512,805514,1039599,126836,940160,29556,776500,26393,101199,368188,112046,340515,952916,741358,275678,416587,662915,678939,890747,712044,848309,984068,321798,638545,618318,431044,774382,614629,954207,357558,837826,500328,375363,37897,598532,339766,4257,531894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 669691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002745s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 669691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001009s ]