SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438703 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438703 [ RunTime:0.001512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299388,635104,880667,163632,866106,219407,565540,838301,158009,298413,646919,626230,733673,392494,690527,411279,294867,29867,765023,129420,268120,695036,950594,402860,85735,221079,863886,567571,1005252,610554,878315,983356,109681,526667,420305,988793,270275,49165,149107,474355,345729,976503,914953,110006,796330,205597,444071,354749,117529,589652,804895,473963,569802,122382,734005,183815,182776,398682,927839,925165) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000387s ]