SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291641 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291641 [ RunTime:0.003176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807774,70345,181058,873728,239392,1027571,652392,661762,714526,855411,613048,188043,776155,534235,740422,572478,492634,880316,887531,288151,768155,165847,149845,985199,818876,512195,867829,719784,935934,694542,646485,426118,941996,715203,370562,898558,484967,529862,231050,195242,871701,760614,1010853,836670,349886,740464,104899,526665,569318,262281,842548,513539,603589,862225,148603,940705,52995,641836,316657,248426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]