SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002482s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548741 LIMIT 1 [ RunTime:0.004477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548741 [ RunTime:0.003798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521357,690294,639790,927929,774759,316063,374553,969354,289211,756865,650907,324006,42224,631140,395788,902419,478165,114484,112793,736999,559419,892096,285528,1011097,383400,962395,413914,98714,202089,857052,231814,592032,146822,876847,127782,4358,820328,650654,142571,167939,694611,518619,828995,160116,141204,804661,186409,108792,91389,667082,186695,358915,330843,504601,829629,697067,263337,860672,373098,614370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.015799s ]