SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424729 LIMIT 1 [ RunTime:0.000938s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424729 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99367,747691,362724,743929,569961,726397,464093,730800,361300,406685,1004322,814305,235546,866716,539382,836027,945563,198430,483057,986503,365822,829733,72224,324885,176491,352950,955126,938665,269797,355343,748209,484920,633886,611247,298684,149798,30386,713631,549601,527477,545662,359228,76645,612876,272911,274243,18129,270581,426072,535225,945423,791392,614411,586800,28434,810609,682382,959929,1011834,769298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424729 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000858s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424729 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]