SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001536s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519063 LIMIT 1 [ RunTime:0.000893s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519063 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82399,131542,134755,921814,731869,951199,671523,841802,792132,779017,731376,381514,334948,144484,484259,239956,262355,204752,398354,807001,735192,439978,408270,396517,383982,963291,261519,670469,1014201,905695,464197,986473,735753,926323,298283,705686,729674,1016460,75938,66211,220172,617126,123128,872194,766889,1017021,137887,241852,622137,544284,696604,316370,751683,966216,384990,631974,898721,371865,346637,216353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000789s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001635s ]