SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 76678 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 76678 [ RunTime:0.004006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (157954,73492,891755,902337,494156,491347,676104,404515,455869,81854,987410,331358,812100,304669,767254,411798,205020,1022886,729713,604657,42065,824180,648788,776103,362394,993991,387103,577118,573702,688173,581080,765330,307642,534861,1024933,11146,846536,1009565,206768,698718,939599,268137,26055,502366,860158,252864,347751,808269,272969,210765,227148,325332,162913,244078,193925,681977,369958,284830,986481,970754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001874s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 76678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000876s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 76678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002953s ]