SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001639s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445092 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445092 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (716670,758096,336538,722952,796614,38091,266411,92585,562777,67628,516465,418633,20255,912793,117966,657265,227465,743406,243841,275975,884910,109728,33007,659229,100381,47064,269479,468418,932185,375158,766196,125329,464701,421341,185185,141113,635980,655958,244800,355884,119003,249188,356858,495875,8338,757254,29754,204873,801075,590770,40542,749482,835301,446245,264670,708224,75195,538126,825906,465674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]