SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508404 LIMIT 1 [ RunTime:0.001922s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508404 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724328,349299,1046753,783764,1017618,300990,938574,633074,744135,633033,1018366,581743,158581,881629,224781,1040440,619777,412034,1045524,462894,385333,949464,875131,620109,475266,259698,967303,541608,703397,901636,490452,273897,1398,190328,472991,392997,381500,347864,679386,521411,691574,741893,150265,899461,282152,476032,226430,675317,457264,415318,148444,106884,125882,376846,245030,213001,602786,22371,95717,191915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000827s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002480s ]