SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569871 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569871 [ RunTime:0.002279s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189021,846690,797784,429961,238412,247827,543070,756439,299017,825251,742322,953022,136194,365102,504027,784623,978910,687485,175133,464936,704984,493129,730297,547560,1038031,711807,412766,677456,167535,347902,63541,224159,66981,1032657,669577,585284,122664,329760,472691,749121,925216,346942,115724,790853,738317,527753,988028,858750,116460,213452,858920,186187,183488,946893,781158,687018,951291,618886,298679,166921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]