SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415084 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415084 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (230871,913024,789831,120550,327589,620918,985725,863192,221357,1044790,79745,399002,805793,346175,241104,490216,136746,189276,234096,682812,489990,68135,994069,608787,874517,805861,967782,484769,150151,712232,1035448,948502,933882,527956,892760,159617,824850,261044,940247,91054,353158,153128,705235,55079,602306,121328,889142,628635,430447,786924,652761,327794,933267,861248,926256,297000,371655,1010277,491290,842965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]